package com.zdsoft.finance.meet.repository;

import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import com.zdsoft.finance.common.base.CustomRepository;
import com.zdsoft.finance.meet.entity.MeetingMember;

/**
 * 参会委员Repository
 * 
 * @author liuwei
 *
 */
public interface MeetingMemberRepository extends CustomRepository<MeetingMember, String> {

	/**
	 * 通过上会项目id集合来查询参会委员集合
	 * 
	 * @param meetingProjectIds
	 *            项目项目id集合
	 * @return 参会委员集合
	 */
	@Query(" from MeetingMember e where e.isDeleted = 0 and e.meetingProject.id in (:meetingProjectIds) ")
	public List<MeetingMember> findByMeetingProjectIds(@Param("meetingProjectIds") List<String> meetingProjectIds);

}
